CREATE PROCEDURE [dbo].[PDA_GetAutoCash] 
@Id_Havaleh VARCHAR(MAX)
AS
SELECT T.K_Qty1,
       T.Id,
       T.Sender,
       T.Price_Forosh,
       T.K_Code,
       K.Name1,
       K.Barcode,
       CASE
           WHEN ISNULL(T.Price_Consumer, 0) = 0 THEN
               T.Price_Forosh
           WHEN T.Price_Consumer < T.Price_Forosh THEN
               T.Price_Forosh
           ELSE
               T.Price_Consumer
       END Price_Consumer,
       K.Point_Flag,
       ISNULL(T.Link_Record, 0) Link_Record,
       ISNULL(T1.Discount,0) Discount,
       ISNULL(T1.Tax,0) Tax
FROM dbo.TmpHavaleh T
    JOIN dbo.KalaId K
        ON T.K_Code = K.K_Code
    LEFT JOIN
    (
        SELECT AutoId,
               SUM(   CASE
                          WHEN OUR.Type = 0 THEN
                              OUR.Price
                          ELSE
                              0
                      END
                  ) Discount,
               SUM(   CASE
                          WHEN OUR.Type = 1 THEN
                              OUR.Price
                          ELSE
                              0
                      END
                  ) Tax
        FROM dbo.Tmp_Over_Under_Row OUR
        --WHERE OUR.AutoId = 22075
        GROUP BY OUR.AutoId
    ) T1
        ON T1.AutoId = T.AutoId
WHERE T.Id_Havaleh = @Id_Havaleh
ORDER BY T.AutoId DESC;

